Tiny File Manager | hub_import

Back Back Up Advanced Editor

<?php
//======================================================================================
//
// Function: Maintain  HUB_IMPORT
//
// Programmer: JKJ
// Date      : 2024-08-30
//
// Copyright Reeft A/S (c) - 2024
//======================================================================================

//======================================================================================
// Get input
//======================================================================================

//======================================================================================
// Make line uppercase
//======================================================================================

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Check if user is logged in?
//======================================================================================
	include "login_check.php";

//======================================================================================
// Get session variables
//======================================================================================

include "include/getsession.php";

// include "include/uuid_create.php";
	// include "include/generate_password_md5.php";

//======================================================================================
// Set language
//======================================================================================

include "include/set_language.php";

//======================================================================================
// Set defaults
//======================================================================================

// $pk_reference  = $_SESSION['session_dft_pk_reference'];
	// $referenceCode = $_SESSION['session_dft_referencecode'];
	// $referenceName = $_SESSION['session_dft_referencename'];

//======================================================================================
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<title><?php echo $datahub_text0001 ?></title>

<link href="css/bootstrap4.3.1/css/bootstrap.custom.min.css" rel="stylesheet">
    <link href="css/bootstrap4.3.1/css/themes/bootstrap.custom.min.css" rel="stylesheet">

<link href="css/custom.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">

<link href="javascript/datatables.3.12/datatables.min.css" rel="stylesheet">
		<script src="javascript/datatables.3.12/datatables.min.js"></script>

.modal-body {
    max-height: calc(100vh - 200px);
    overflow-y: auto; }
	
.btn-custom-wide {
	height:60px;
	width:210px;
}

.text-truncate-dt {
    max-width: 450px;
	white-space: nowrap;
    overflow: hidden;
	text-overflow: ellipsis;

}

.text-align-dt {
    text-align: center;
}

.modal-xxl {
    max-width: 80%;
}

.modal-xl {
    max-width: 50%;
}

.border-3 {
    border-width:3px !important;
}

td .hover-img {
  position:relative;
 }
td .hover-img span {
  position:absolute; left:-9999px; top:-9999px; z-index:9999;
 }
td:hover .hover-img span {
  top: 5px;
  left:0px;
 }

.chosen-container-single {
    min-width: 100%;
}

</style>

//=============================================================================
// Globals
//=============================================================================

var thisCurrentRow;
	var thisGlobalRowData;
    var thisGlobalTableData;

var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A = 'Text/Char';
	var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N = 'Number/Value';
	var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L = 'Date (ISO)';
	var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T = 'Time (ISO)';

var GLOBAL_CONFIG_RPYIFSPATH = '';
	var GLOBAL_CONFIG_RPYIFSLIBR = '';

// Save field
	var save_IPFILENAME = '';
	var save_IPIMPSEQ 	= '';

var global_debug = 'N';

// Add allowed Y/N
	var GLOBAL_ADD_ALLOWED = 'Y';

// Show group buttons
	var GLOBAL_SHOW_GROUP_BUTTONS = 'N';

// Delete allowed Y/N
	var GLOBAL_DELETE_ALLOWED = 'Y';

// sortMode
	var GLOBAL_SORTMODE = 'DESC';

var jsonDataSave = {};

var DFT_DATE_DISPLAY_FORMAT 	=  '<?php //echo $DFT_DATE_DISPLAY_FORMAT ?>';
	var DFT_LANGUAGE 				=  '<?php //echo $DFT_LANGUAGE ?>';

var GLOBAL_TOTALPAGESSTOPVALUE	=  10;

// Save field
	//var save_CFGNAM = '';

$(function () {
	  $.scrollUp({
		scrollName: 'scrollUp', // Element ID
		//topDistance: '1800', // Distance from top before showing element (px)
		//topSpeed: 300, // Speed back to top (ms)
		scrollDistance: '300', // Distance from top before showing element (px)
		scrollSpeed: 300, // Speed back to top (ms)
		animation: 'fade', // Fade, slide, none
		animationInSpeed: 200, // Animation in speed (ms)
		animationOutSpeed: 200, // Animation out speed (ms)
		scrollText: false, //'Scroll to top', // Text for element
		activeOverlay: false, // Set CSS color to display scrollUp active point, e.g '#00FFFF'
	  });
	});

//=============================================================================
// Get data
//=============================================================================
function getData( inputGetData )
{

// Reset, show all
	if ( inputGetData == '*RESET' ) {
		inputGetData = '';

//Clear search
		thisGlobalTableData.search( '' );

}

//Only initialize datatables once, else just draw it
	if ( $.fn.dataTable.isDataTable( '#REEFTvisual_data' ) ) {
		thisGlobalTableData.draw(); // fire in the hole
	}
	else {
		setDataTables();
	}

}

//=============================================================================
// Set datatables
//=============================================================================
function setDataTables()
{

// Delete allowed?
	if ( GLOBAL_DELETE_ALLOWED == 'Y' ) {
		var show_the_delete_button = true;
	} else {
		var show_the_delete_button = false;
	}

new $('#REEFTvisual_data').DataTable({
		"ajax": {
			"url": 'hub_import_maintain_get.php',
			"type": "POST",
			"data": function (parmData) {

// Add custom parameters to the ajax call

// Get the current date line
				input_IPFILENAME = $('#input-IPFILENAME').val();

// Webservice name
				parmData.IPFILENAME	 = input_IPFILENAME;

},
			dataSrc: function (jsonData) {  //return data

var rpyCMPNO			= jsonData.header.rpyCMPNO;
				var rpyCMPNO_Name		= jsonData.header.rpyCMPNO_Name;
				var rpyFile_name		= jsonData.header.rpyFile_name
				var rpyFile_description	= jsonData.header.rpyFile_description
				var rpyTableRecordsFound= jsonData.header.rpyTableRecordsFound

var returnCode 			= jsonData.header.returnCode;
				var returnMsg 			= jsonData.header.returnMsg;
				var entries_found 		= jsonData.header.entries_found;
				var response_sec 		= jsonData.header.response_sec;

// Some default data
				GLOBAL_CONFIG_RPYIFSLIBR = jsonData.header.rpyDTAlibr;
				GLOBAL_CONFIG_RPYIFSPATH = jsonData.header.rpyIFSpath;

// Show load time
				$('#text-total-records-found').html( rpyTableRecordsFound );
				$('#load-time-from-database').html('entries found: ' + entries_found + ' (' + response_sec + ')');

// Set Company and file information
				if ( rpyFile_name != '' ) {
					$('#data-hub-company-information').html( '<span title="' + rpyFile_name + ' - ' + rpyFile_description + '">' + rpyCMPNO_Name + ' (' + rpyCMPNO + ')' + '</span>' ).css('font-size','1.3em');
				}

// Init button line fields
				var HTMLlineButtons 		= '';
				var HTMLlineButtonsModal 	= '';
				var selectedButtonClass 	= 'btn-dark';

//=====================================================================================
				// Create group buttons, only if wanted
				//=====================================================================================
				if ( GLOBAL_SHOW_GROUP_BUTTONS == 'Y' ) {

$.each( jsonData.header_buttons, function( index, object ){
						var buttonLine   = object.buttonLine;
						var buttonCount	 = object.buttonCount;

if ( input_IPFILENAME == buttonLine ) {
							selectedButtonClass = 'btn-success';
						} else {
							selectedButtonClass = 'btn-dark';
						}

var selectButtonLineID 		= 'select-button-line-id-' + buttonLine;
						var selectButtonLineIDmodal = 'select-button-line-id-modal-' + buttonLine + '_' + buttonCount;

HTMLlineButtons 		+=	'<button type="button" onclick="setWebserviceSearch(\'' + buttonLine + '\')" style="cursor:default" id="' + selectButtonLineID + '" class="btn ' + selectedButtonClass + ' select-button-line btn-sm mr-1 mb-1">'
												+ 	buttonLine + ' (<b>' + buttonCount + '</b>)'
												+	'</button>'

HTMLlineButtonsModal 	+=	'<button type="button" onclick="selectGroupValueModal(\'' + buttonLine + '\')" style="width:100px" id="' + selectButtonLineIDmodal + '" class="select-button-line-modal btn btn-primary btn-sm mr-1 mb-1">'
												+ 	buttonLine
												+	'</button>'

});

// Reset
					HTMLlineButtons 		+=	'<button type="button" onclick="setWebserviceSearch(\'' + '' + '\')" style="cursor:default" id="' + 'RESET' + '" class="btn ' + 'btn-warning' + ' select-button-line btn-sm mr-1 mb-1">'
											+ 	'<b>' + 'RESET' + '</b>'
											+	'</button>'

// $('#data-result-button-group').html(HTMLlineButtons);
					// $('#data-result-button-group-modal').html(HTMLlineButtonsModal);

}
				//=====================================================================================

return jsonData.data;
			}
		},
		processing: true,
		serverSide: true,
		responsive: true,
		fixedHeader: true,
        order: [[ 0, "asc" ],[ 1, "asc" ]],
		columns:
				[
                    { data: "IPIMPSEQ" }, 	// 0
                    { data: "IPFILENAME" }, // 1
					{ data: "IPFILENMWK" }, // 2
					{ data: "IPLIBRNAME" }, // 3
					{ data: "IPFILEDESC" }, // 4
					{
						// 5
						// Since we are combining multiple data fields, use null as the data source
			            data: null,
			            //data: "IPCPYMAIN",
						render: function (data, type, row, meta)
						{

IPCPYMAIN = $('#modal-input-IPCPYMAIN').val();
							if ( IPCPYMAIN != '' ) {
								row.IPCPYMAIN = IPCPYMAIN;
							}

if ( row.IPCPYMAIN == 'Y') {
								var IPCPYMAINtext = '<div class="text-center text-success"><?php echo $datahub_YES ?></div>';
							} else {
								var IPCPYMAINtext = '<div class="text-center text-danger font-weight-bold"><?php echo $datahub_NO ?></div>';
							}

return IPCPYMAINtext;
						}
					},
					{
						// 6
						// Since we are combining multiple data fields, use null as the data source
			            data: null,
			            //data: "IPCLRMAIN",
						render: function (data, type, row, meta)
						{

IPCLRMAIN = $('#modal-input-IPCLRMAIN').val();
							if ( IPCLRMAIN != '' ) {
								row.IPCLRMAIN = IPCLRMAIN;
							}

if ( row.IPCLRMAIN == 'Y') {
								var IPCLRMAINtext = '<div class="text-center text-success"><?php echo $datahub_YES ?></div>';
							} else {
								var IPCLRMAINtext = '<div class="text-center text-danger font-weight-bold"><?php echo $datahub_NO ?></div>';
							}

return IPCLRMAINtext;
						}
					},
					{
						// 7
						// Since we are combining multiple data fields, use null as the data source
			            data: null,
			            //data: "IPCPYF",
						render: function (data, type, row, meta)
						{

IPCPYF = $('#modal-input-IPCPYF').val();
							if ( IPCPYF != '' ) {
								row.IPCPYF = IPCPYF;
							}

if ( row.IPCPYF == 'Y') {
								var IPCPYFtext = '<div class="text-center text-success"><?php echo $datahub_YES ?></div>';
							} else {
								var IPCPYFtext = '<div class="text-center text-danger font-weight-bold"><?php echo $datahub_NO ?></div>';
							}

return IPCPYFtext;
						}
					},
					{ data: "IPCPYOPT"	},	// 8
					{
						// 9
						// Since we are combining multiple data fields, use null as the data source
			            data: null,
						render: function (data, type, row, meta)
						{

// Coming from the server program HUB_IMPORT
							RUN_SQL_PGM = $('#modal-input-RUN_SQL_PGM').val();
							if ( RUN_SQL_PGM != '' ) {
								row.RUN_SQL_PGM = RUN_SQL_PGM;
							}

if ( row.RUN_SQL_PGM == 'Y') {
								var RUN_SQL_PGM_text = '<div class="text-center text-success font-weight-bold"><?php echo $datahub_YES ?></div>';
							} else {
								var RUN_SQL_PGM_text = '<div class="text-center text-danger"><?php echo $datahub_NO ?></div>';
							}

return RUN_SQL_PGM_text;
						}
					},
					{
						// 10
						// Since we are combining multiple data fields, use null as the data source
			            data: null,
			            //data: "IPACTIV",
						render: function (data, type, row, meta)
						{

IPACTIV = $('#modal-input-IPACTIV').val();
							if ( IPACTIV != '' ) {
								row.IPACTIV = IPACTIV;
							}

if ( row.IPACTIV == '1') {
								var IPACTIVtext = '<div class="text-center text-success"><?php echo $datahub_YES ?></div>';
							} else {
								var IPACTIVtext = '<div class="text-center text-danger font-weight-bold"><?php echo $datahub_NO ?></div>';
							}

return IPACTIVtext;
						}
					},
					{
						// 11
						// Since we are combining multiple data fields, use null as the data source
						data: null,
						render: function (data, type, row, meta)
						{
							// Create edit button
							var myButton = '<button id="edt-' + row.IPFILENAME + '" class="edit-btn btn btn-primary btn-block mr-1"><?php echo $datahub_button_edit ?></button>';
							return myButton;
						}
					},
					{
						// 12
						// Since we are combining multiple data fields, use null as the data source
						data: null,
			            // data: "IPFILENAME",
						render: function (data, type, row, meta)
						{
							// Create delete button
							var myButton = '<button id="dlt-' + row.IPFILENAME + '" class="delete-btn btn btn-danger btn-block mr-1"><?php echo $datahub_button_delete ?></button>';
							return myButton;
						}
					},
                    { data: "IPACTIV" 	}, 	// 13
                    { data: "IPIFSNAME" }, 	// 14
                    { data: "IPIFSDESC" }, 	// 15
					{ data: "IPRUNSQL"	},	// 16
					{ data: "IPSQLWHR"	},	// 17
					{ data: "IPSQLSMT"	},	// 18
					{ data: "IPRUNPGM"	},	// 19
					{ data: "IPPGMWHR"	},	// 20
					{ data: "IPPGMSMT"	},	// 21
					{ data: "IPCGHATT"	},	// 22
					{ data: "IPCPYMAIN" }, 	// 23
                    { data: "IPCLRMAIN" },	// 24
					{ data: "IPCPYF"	},	// 25
					{ data: "IPPATTERN"	}	// 26
                ],
		columnDefs: [

// Make sure that buttons are not "hided" when responsive kicks in
				{ responsivePriority: 1, targets: 11 },
				{ responsivePriority: 2, targets: 12 },
				{ responsivePriority: 3, targets: 1 },
				{ responsivePriority: 4, targets: 10 },

// Setup the look and feel of the columns
				{
				"targets": [ 11 ],
				"visible": true,
				"searchable": false,
				 "orderable": false
				},
				{
				"targets": [ 12 ],
				"visible": show_the_delete_button,
				"searchable": false,
				"orderable": false,
				},
				{
				"targets": [ 3,4 ],
				"visible": true,
				"searchable": true,
				"orderable": false
				},
				{
				"targets": [ 5,6,7,8,9 ],
				"visible": true,
				"searchable": false,
				"orderable": false
				},
				{
				"targets": [ 13,14,15,16,17,18,19,20,21,22,23,24,25,26 ],
				"visible": false,
				"searchable": false,
				"orderable": false
				},
				{
				"targets": [ 4 ],
				"className": "text-truncate-dt"  //class to mimic text-truncate in dt
				},
				{
				"targets": [ 0 ],
				"width": '100px',
				"className": "text-align-dt"
				},
				{
				"targets": [ 5,6,7,9 ],
				"width": '60px',
				"className": "text-align-dt"
				}

],
		pageLength: 10,
		layout: {
			top1Start:
			[{
				pageLength: {
					menu: [10, 25, 50, 100, 250]
				}
			}],
			top1End:
			[{
				search: {
					placeholder: '<?php echo $datahub_datatable_Search_text ?>',
					processing: true
				}
			}],
			topStart: {
				info:{
					 }
			},
			topEnd: {
				paging: {
					buttons: 7,
					firstLast: true,
					boundaryNumbers: true,
				}
			},
			bottomStart: {
				buttons: [
					{
						extend: 'copyHtml5',
						text: '<img src="images/copy.png" height="25"> Copy to Clipboard',
						titleAttr: 'Copy',
						title: 'DATAHUB - Config Data Export - Copy to clipboard',
						exportOptions: {
							// Fields to export (https://datatables.net/reference/button/csv#Examples)
							columns: [0,1,2,3,4,5,6,7,26]
						}

},
					{
						extend: 'excelHtml5',
						text: '<img src="images/microsoft_excel_logo.png" height="25"> Excel',
						titleAttr: 'Excel',
							title: function(){
								return 'DATAHUB transactions file export';
							},
							filename: function(){
								//var p_id = $('#input-IPFILENAME').val();
								var p_id = moment().format('YYYY-MM-DD HH.mm.ss');
								return 'DATAHUB - Config Data Export - Excel - ' + p_id;
							},
							exportOptions: {
								// Fields to export (https://datatables.net/reference/button/csv#Examples)
								columns: [0,1,2,3,4,5,6,7,26]
							}
					},
					{
						extend: 'pdfHtml5',
						text: '<img src="images/pdf_logo.png" height="25"> PDF',
						titleAttr: 'PDF',
						orientation: 'landscape',
						title: 'DATAHUB - Config Data Export - PDF',
						filename: function(){
								//var p_id = $('#input-IPFILENAME').val();
								var p_id = moment().format('YYYY-MM-DD HH.mm.ss');
								return 'DATAHUB - Config Data Export - Excel - ' + p_id;
						},
						exportOptions: {
							// Fields to export (https://datatables.net/reference/button/csv#Examples)
						columns: [0,1,2,3,4,5,6,7,26],
						modifier: {
							page: 'all'
							}
						}
					}
				]
			},
			bottomEnd: {
				paging: {
					buttons: 7,
					firstLast: true,
					boundaryNumbers: true
				}
			}
		},
		language:
		{
					"decimal":        ",",
					"thousands":      ".",
					"emptyTable":     "<?php echo $datahub_datatable_emptyTable ?>",
					"info":           "<?php echo $datahub_datatable_Info ?>",
					"infoEmpty":      "<?php echo $datahub_datatable_InfoEmpty ?>",
					"InfoFiltered":   "<?php echo $datahub_datatable_InfoFiltered ?>",
					"infoPostFix":    "",
					"lengthMenu":     "<?php echo $datahub_datatable_LengthMenu ?>",
					"loadingRecords": "",
					"processing":     "<?php echo $datahub_datatable_Processing ?>",
					"search":         "<?php echo $datahub_datatable_Search ?>",
					"zeroRecords":    "<?php echo $datahub_datatable_ZeroRecords ?>",
					"paginate":
						{
							"first":    "<?php echo $datahub_datatable_First ?>",
							"last":     "<?php echo $datahub_datatable_Last ?>",
							"next":     "<?php echo $datahub_datatable_Next ?>",
							"previous": "<?php echo $datahub_datatable_Previous ?>"
						},
					"aria": {
						"orderable":  "Order by this column",
						"orderableReverse": "Reverse order this column"
					}

},
		createdRow: function (row, data, dataIndex) {

},
		rowCallback: function (row, data, displayNum, displayIndex)
		{

},
        "preDrawCallback": function(settings)
		{
		},
		"initComplete": function ()
		{

}

});

//=============================================================================
	// Setup the data to be able to update the table without reloading from the server
	//=============================================================================

// Save the table in a global variable
		thisGlobalTableData = $('#REEFTvisual_data').DataTable();

// Handle click on "Edit" button
		$('#REEFTvisual_data tbody').on('click', '.edit-btn', function() {
			thisCurrentRow 	= $(this).closest('tr');
			thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();

// Debug
			// console.log("edit");
			// console.log(thisGlobalRowData);
			//console.log(thisCurrentRow);

dataChange();

});

// Handle click on "Delete" button
		$('#REEFTvisual_data tbody').on('click', '.delete-btn', function() {
			thisCurrentRow 	= $(this).closest('tr');
			thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();

// Debug
			// console.log(thisGlobalRowData);
			// console.log(thisCurrentRow);

dataDeleteConfirm();

});

//=============================================================================

//=============================================================================
	// Place curor in search field
	//=============================================================================
	$('div.dt-search .dt-input').focus();
	//=============================================================================

}

//=============================================================================
// Reason addd  -- not used
//=============================================================================
function dataAdd ( input_pk_type )
{

var myIPFILENAME = $('#input-IPFILENAME').val();

resetModalInputFields();
			setModalInputDefaultFields();

$('#input-mode').val('*add');

// Reset save field
			save_IPFILENAME = '';

// Set Yes/No buttons
			set_YES_NO_Button( 'N', 'IPCPYMAIN', 'value' );
			set_YES_NO_Button( 'N', 'IPCLRMAIN', 'value' );
			set_YES_NO_Button( 'Y', 'IPCPYF', 	 'value' );
			set_YES_NO_Button( 'N', 'IPRUNSQL',  'value' );
			set_YES_NO_Button( 'N', 'IPRUNPGM',  'value' );
			set_YES_NO_Button( 'N', 'IPCGHATT',  'value' );
			set_YES_NO_Button( '0', 'IPACTIV',   'bool' );

// Reset modal message
			resetModalMessage();

// Remove key fields readonly
			$('#modal-input-IPFILENAME').removeAttr('readonly','readonly');
			$('#data-result-button-group-modal').removeClass('d-none');

// Show modal
			$('#hub_import_MaintainModal').modal('show');

// Show notice text
			$('#text-add-notice').removeClass('d-none');

$('#hub_import_MaintainModal').on('shown.bs.modal', function () {
				$('#modal-input-IPFILENAME').trigger('focus');
			})

}

//=============================================================================
// Show details
//=============================================================================
function dataChange( )
{

var row = thisGlobalRowData;

//console.table(row)

// Save in fields
	var counter     = row["counter"];

var IPACTIV   		= row["IPACTIV"];
	var IPFILENAME		= row["IPFILENAME"];
	var IPIMPSEQ  		= row["IPIMPSEQ"];
	var IPFILENMWK		= row["IPFILENMWK"];
	var IPLIBRNAME		= row["IPLIBRNAME"];
	var IPFILEDESC		= row["IPFILEDESC"];
	var IPIFSNAME 		= row["IPIFSNAME"];
	var IPIFSDESC 		= row["IPIFSDESC"];
	var IPPATTERN 		= row["IPPATTERN"];
	var IPCPYMAIN 		= row["IPCPYMAIN"];
	var IPCLRMAIN 		= row["IPCLRMAIN"];
	var IPCPYF  		= row["IPCPYF"];
	var IPCPYOPT		= row["IPCPYOPT"];
	var IPRUNSQL		= row["IPRUNSQL"];
	var IPSQLWHR		= row["IPSQLWHR"];
	var IPSQLSMT		= row["IPSQLSMT"];
	var IPRUNPGM		= row["IPRUNPGM"];
	var IPPGMWHR		= row["IPPGMWHR"];
	var IPPGMSMT		= row["IPPGMSMT"];
	var IPCGHATT		= row["IPCGHATT"];
	var RUN_SQL_PGM		= row["RUN_SQL_PGM"];

$('#input-mode').val('*update');

save_IPFILENAME =	IPFILENAME;
	save_IPIMPSEQ	=	IPIMPSEQ

// Move to input fields
	$('#modal-input-counter').val(counter);

$('#modal-input-IPFILENAME').val( IPFILENAME );

$('#modal-input-IPACTIV').val( IPACTIV );
	$('#modal-input-IPIMPSEQ').val( IPIMPSEQ );
	$('#modal-input-IPFILENMWK').val( IPFILENMWK );
	$('#modal-input-IPLIBRNAME').val( IPLIBRNAME );
	$('#modal-input-IPFILEDESC').val( IPFILEDESC );
	$('#modal-input-IPIFSNAME').val( IPIFSNAME );
	$('#modal-input-IPIFSDESC').val( IPIFSDESC );
	$('#modal-input-IPPATTERN').val( IPPATTERN );
	$('#modal-input-IPCPYMAIN').val( IPCPYMAIN );
	$('#modal-input-IPCLRMAIN').val( IPCLRMAIN );
	$('#modal-input-IPCPYF').val( IPCPYF );
	$('#modal-input-IPCPYOPT').val( IPCPYOPT );
	$('#modal-input-IPRUNSQL').val( IPRUNSQL );
	$('#modal-input-IPSQLWHR').val( IPSQLWHR );
	$('#modal-input-IPSQLSMT').val( IPSQLSMT );
	$('#modal-input-IPRUNPGM').val( IPRUNPGM );
	$('#modal-input-IPPGMWHR').val( IPPGMWHR );
	$('#modal-input-IPPGMSMT').val( IPPGMSMT );
	$('#modal-input-IPCGHATT').val( IPCGHATT );

$('#modal-input-RUN_SQL_PGM').val( RUN_SQL_PGM );

// Check IPACTIVe code
	if ( IPACTIV != '1' && IPACTIV != '0' ) {
		IPACTIV = '1';
	}

// Set run where
	set_RUN_WHERE( IPSQLWHR, 'IPSQLWHR');
	set_RUN_WHERE( IPPGMWHR, 'IPPGMWHR');

// Set CpyF options
	setCpyF_option( IPCPYOPT );

// Set Yes/No buttons
	set_YES_NO_Button( IPCPYMAIN, 	'IPCPYMAIN', 'value' );
	set_YES_NO_Button( IPCLRMAIN, 	'IPCLRMAIN', 'value' );
	set_YES_NO_Button( IPCPYF, 		'IPCPYF', 	 'value' );
	set_YES_NO_Button( IPRUNSQL, 	'IPRUNSQL',  'value' );
	set_YES_NO_Button( IPRUNPGM, 	'IPRUNPGM',  'value' );
	set_YES_NO_Button( IPCGHATT, 	'IPCGHATT',  'value' );
	set_YES_NO_Button( IPACTIV, 	'IPACTIV',   'bool' );

// Make key fields readonly
	$('#modal-input-IPFILENAME').attr('readonly','readonly');
	$('#data-result-button-group-modal').removeClass('d-none');

$('.read-only-class').attr('readonly','readonly');

// Reset modal message
	resetModalMessage();

// Hide notice text
	$('#text-add-notice').addClass('d-none');

// Show modal
	$('#hub_import_MaintainModal').modal('show');

$('#hub_import_MaintainModal').on('shown.bs.modal', function () {
		$('#modal-input-IPIMPSEQ').trigger('focus');
	})

}

//=============================================================================
// Save
//=============================================================================
function dataSave()
{
	// Reset modal message
	resetModalMessage();

// Check if the is a mark as filename exist, if yes show error
	if ( $('#input-IPFILENAME-exist').val() == 'Y' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0091 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-IPFILENAME').trigger('focus');
		return false;
	}

// Check content of fields
	if ( $('#modal-input-IPFILENAME').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0088 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-IPFILENAME').trigger('focus');
		return false;
	}

if ( $('#modal-input-IPFILENMWK').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0090 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-IPFILENMWK').trigger('focus');
		return false;
	}

if ( $('#modal-input-IPLIBRNAME').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0089 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-IPLIBRNAME').trigger('focus');
		return false;
	}

if ( $('#modal-input-IPIFSNAME').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0091 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-IPIFSNAME').trigger('focus');
		return false;
	}

if ( $('#modal-input-IPPATTERN').val() == '' ) {
		$('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0096 ?>' );
		$('#modal-save-button').addClass('disabled').prop("disabled", true);
		$('#modal-input-IPPATTERN').trigger('focus');
		return false;
	}

var mode = $('#input-mode').val();

//===============================================================================
	// Remove # if any
	//===============================================================================

// Setup remove string
		let mySaveString;

var myWorkField = $('#modal-input-IPFILENMWK').val();
		myWorkField = myWorkField.replace("#", "");
		$('#modal-input-IPFILENMWK').val( myWorkField );

var myWorkField = $('#modal-input-IPLIBRNAME').val();
		myWorkField = myWorkField.replace("#", "");
		$('#modal-input-IPLIBRNAME').val( myWorkField );

//===============================================================================

// Make sure key does not have space and are in uppercase
	// var myWorkField = $('#modal-input-IPFILENAME').val();
	// myWorkField = myWorkField.replace(" ", "_");
	// myWorkField = myWorkField.toUpperCase();
	// $('#modal-input-IPFILENAME').val( myWorkField );

// Make array and json
	var myData = $('#dataForm').find('input, select, textarea').serializeArray();

var result = JSON.stringify(myData);

var result = encodeURIComponent( result );
	// console.log(result);
	// console.log(myData);
	// return;

var parmData = 'data=' + result
				 + '&mode=' + mode
				 ;

$.ajax({
		url: "hub_import_maintain_save.php",
		type: "POST",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

//=================================================================
		// START - Update the table without doing a server reload
		// Only update
		//=================================================================
		if ( mode == '*update' ) {

event.preventDefault();

//			var myACTIV = $('#modal-input-ACTIV').val();

// console.log('myACTIV 1: ' + myACTIV)

// if ( myACTIV == '1') {
				// myACTIVtext = '<div class="text-center">Yes</div>';
				// myACTIVtext = 'YES';
			// } else {
				// myACTIVtext = '<div class="text-center">No</div>';
				// myACTIVtext = 'NO';
			// }

// Debug
			// console.log(myGlobalRowData[0]);
			// console.log(myGlobalRowData[1]);
			// console.log(myGlobalRowData[2]);
			// console.log(myCurrentRow);
			// console.table(myGlobalTableData);

// Get the data for the "Change/Delete button", so we do not need to create it again
			// myChangeButtonData = myGlobalRowData[6];
			// myDeleteButtonData = myGlobalRowData[7];

//==============================================
			// Use this if you want to update the whole row
			//==============================================
			// myGlobalTableData.row(myCurrentRow).data([
														// modal_input_IPFILENAME,
														// modal_input_LSTCAL,
														// modal_input_IPFILENMWK1,
														// modal_input_IPFILENMWK2,
														// modal_input_COUNT,
														// modal_input_SERTYP,
														// myChangeButtonData,
														// myDeleteButtonData,
														// modal_input_IPFILENMWK1,
														// modal_input_IPFILENMWK2
													// ])
													// .draw(false)
													// ;

// console.log(thisGlobalTableData.cell(thisCurrentRow,  16 ).data() );
			// console.log(thisGlobalTableData.cell(thisCurrentRow,  19 ).data() );

//=======================================================
			// Use this if you want to update one or more table cells
			//=======================================================
			thisGlobalTableData.cell(thisCurrentRow,  0  ).data($('#modal-input-IPIMPSEQ').val() );
			thisGlobalTableData.cell(thisCurrentRow,  1  ).data($('#modal-input-IPFILENAME').val() );
			thisGlobalTableData.cell(thisCurrentRow,  2  ).data($('#modal-input-IPFILENMWK').val() );
			thisGlobalTableData.cell(thisCurrentRow,  3  ).data($('#modal-input-IPLIBRNAME').val() );
			thisGlobalTableData.cell(thisCurrentRow,  4  ).data($('#modal-input-IPFILEDESC').val() );
			thisGlobalTableData.cell(thisCurrentRow,  5  ).data($('#modal-input-IPCPYMAIN').val() );
			thisGlobalTableData.cell(thisCurrentRow,  6  ).data($('#modal-input-IPCLRMAIN').val() );
			thisGlobalTableData.cell(thisCurrentRow,  7  ).data($('#modal-input-IPCPYF'	  ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  8  ).data($('#modal-input-IPCPYOPT' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  9  ).data($('#modal-input-RUN_SQL_PGM' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  10 ).data($('#modal-input-IPACTIV').val() );
			// 11 = Edit button
			// 12 = Delete button
			thisGlobalTableData.cell(thisCurrentRow,  13 ).data($('#modal-input-IPACTIV'  ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  14 ).data($('#modal-input-IPIFSNAME').val() );
			thisGlobalTableData.cell(thisCurrentRow,  15 ).data($('#modal-input-IPIFSDESC').val() );
			thisGlobalTableData.cell(thisCurrentRow,  16 ).data($('#modal-input-IPRUNSQL' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  17 ).data($('#modal-input-IPSQLWHR' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  18 ).data($('#modal-input-IPSQLSMT' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  19 ).data($('#modal-input-IPRUNPGM' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  20 ).data($('#modal-input-IPPGMWHR' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  21 ).data($('#modal-input-IPPGMSMT' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  22 ).data($('#modal-input-IPCGHATT' ).val() );

thisGlobalTableData.cell(thisCurrentRow,  23 ).data($('#modal-input-IPCPYMAIN' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  24 ).data($('#modal-input-IPCLRMAIN' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  25 ).data($('#modal-input-IPCPYF' ).val() );
			thisGlobalTableData.cell(thisCurrentRow,  26 ).data($('#modal-input-IPPATTERN' ).val() );

//console.log(save_IPIMPSEQ + ' ' + $('#modal-input-IPIMPSEQ').val() );

// If seq has changed reorder table
			if ( save_IPIMPSEQ != $('#modal-input-IPIMPSEQ').val() ) {
				thisGlobalTableData.draw(false);
			}

}
		//=================================================================
		// END - Update the table without doing a server reload
		//=================================================================

//=================================================================
		// Close the modal
		//=================================================================
		$('#hub_import_MaintainModal').modal('hide');

//=================================================================
		// Only when add
		//=================================================================
		if ( mode == '*add' ) {
			var myButtonID = 'select-button-line-id-' + $('#input-IPFILENAME').val();
			$('#' + myButtonID).click();
			getData('');
		}

})
	.always(function( jsonData ) {

// Reset mode
		$('#input-mode').val('');

// Reset input fields
		resetModalInputFields();

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( thrownError );
		console.log( xhr );

});

}

//=============================================================================
// Delete confirm
	//=============================================================================
function dataDeleteConfirm( )
{

$('#input-mode').val('*delete');

var row = thisGlobalRowData;

var input_IPFILENAME = row["IPFILENAME"];

$('#confirm-delete-IPFILENAME').val(input_IPFILENAME);

// Create confirm text
	$('#confirm-delete-text-IPFILENAME').html(input_IPFILENAME);

$('#hub_import_confirmDeleteModal').modal('show');

}

//=============================================================================
// Delete
//=============================================================================
function dataDeleteExec()
{
	// Reset modal message
	resetModalMessage();

var mode = $('#input-mode').val();

// Make array and json
	var myData = $('#dataForm-delete').find('input, select').serializeArray();
	var result = JSON.stringify(myData);

// console.log(result);
	// console.log(myData);
	//return;

var parmData = 'data=' + result
				 + '&mode=' + mode
				 ;

$.ajax({
		url: "hub_import_maintain_save.php",
		type: "POST",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

$('#hub_import_confirmDeleteModal').modal('hide');

//=================================================================
	// Only when add
	//=================================================================
	if ( mode == '*delete' ) {
		var myButtonID = 'select-button-line-id-' + $('#input-IPFILENAME').val();
		$('#' + myButtonID).click();

resetModalInputFields();

getData('');
	}

})
	.always(function( jsonData ) {

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( xhr );

});

}

//=============================================================================
// Check if userid exists
//=============================================================================
function checkDataExists()
{

// If not *add, just leave
	if ( $('#input-mode').val() != '*add' ) {
		return false;
	}

var IPFILENAME = $('#modal-input-IPFILENAME').val();

// If update, then the "orginal" code is ok
	if ( $('#input-mode').val() == '*update' ) {
		if ( IPFILENAME == save_IPFILENAME ) {
	//		return;
		}
	}

var parmData = 'ipfilename=' + IPFILENAME
				 ;

$.ajax({
		url: "hub_impchk_get.php",
		type: "GET",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

var returnCode 				= jsonData.header.returnCode;
		var returnMsg 				= jsonData.header.returnMsg;
		var entries_found 			= jsonData.header.entries_found;

var returnDataValue		 	= jsonData.header.returnDataValue;
		var returnDataValueText		= jsonData.header.returnDataValueText;

if ( returnDataValue == '50') {
			$('#modal-message').addClass(' border-bottom').html( '<?php echo $datahub_error0091 ?>' );
			$('#modal-save-button').addClass('disabled').prop("disabled", true);
			$('#modal-input-IPFILENAME').trigger('focus');

// Set mark
			$('#input-IPFILENAME-exist').val('Y');
			return false;
		} else {
			$('#input-IPFILENAME-exist').val('N');
			// IPFILENMWK = jsonData.detail[0].IPFILENMWK
			// $('#modal-input-M1UPP').val( IPFILENMWK );
		}

// Reset modal message
		resetModalMessage();

})
	.always(function( jsonData ) {

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( xhr );

});

}

//=============================================================================
// Show deleted
//=============================================================================
function showDeleted()
{

var show_deleted = $('#input-show-deleted').val();

if ( show_deleted == 'Y' ) {
		$('#button-show-deleted').html('<?php echo $datahub_NO ?>');
		$('#input-show-deleted').val('N');
	} else {
		$('#button-show-deleted').html('<?php echo $datahub_YES ?>');
		$('#input-show-deleted').val('Y');
	}

}

//=============================================================================
// Set CpyF option
//=============================================================================
function setCpyF_option( inputValue )
{

$('.cpy_opt-button').removeClass('btn-success').addClass('btn-primary');

if ( inputValue == '*ADD' ) {
		$('#button-add-IPCPYOPT').removeClass('btn-primary').addClass('btn-success');
	}

if ( inputValue == '*REPLACE' ) {
		$('#button-rpl-IPCPYOPT').removeClass('btn-primary').addClass('btn-success');
	}

if ( inputValue == '*UPDADD' ) {
		$('#button-upd-IPCPYOPT').removeClass('btn-primary').addClass('btn-success');
	}

$('#modal-input-IPCPYOPT').val(inputValue);

}

//=============================================================================
// Set Yes/No button
//=============================================================================
function set_YES_NO_Button( inputValue, inputID, inputType )
{

// Bool
	if ( inputType == 'bool' )
	{
		if (inputValue == '')
		{
			inputValue = '0';
		}
	}

// Value
	if ( inputType == 'value' )
	{
		if (inputValue == '')
		{
			inputValue = 'N';
		}
	}

var yesID 	= 'button-yes-'  + inputID;
	var noID 	= 'button-no-' 	 + inputID;
	var thisID 	= 'modal-input-' + inputID;

if ( inputType == 'bool' ) {
		if ( inputValue == '1' ) {
			$('#' + yesID).removeClass('btn-primary').addClass('btn-success');
			$('#' + noID).removeClass('btn-success').addClass('btn-primary');
		} else {
			$('#' + yesID).removeClass('btn-success').addClass('btn-primary');
			$('#' + noID).removeClass('btn-primary').addClass('btn-success');
		}
	}

if ( inputType == 'value' ) {
		if ( inputValue == 'Y' ) {
			$('#' + yesID).removeClass('btn-primary').addClass('btn-success');
			$('#' + noID).removeClass('btn-success').addClass('btn-primary');
		} else {
			$('#' + yesID).removeClass('btn-success').addClass('btn-primary');
			$('#' + noID).removeClass('btn-primary').addClass('btn-success');
		}
	}

// Set value for input field
	$('#' + thisID).val(inputValue);

//------------------------------------------------------------
	// Active button, hide test
	//------------------------------------------------------------
	if ( inputID == 'IPACTIV' ) {
		$('#text-add-notice').addClass('d-none');
		$('#modal-input-IPFILENAME').focus();
	}

//------------------------------------------------------------

//------------------------------------------------------------
	// Check RUN SQL/PGM
	//------------------------------------------------------------
	if ( inputID == 'IPRUNSQL' || inputID == 'IPRUNPGM'  ) {

var a1 = $('#modal-input-IPRUNSQL').val();
		var a2 = $('#modal-input-IPRUNPGM').val();
		if ( a1 == 'Y' || a2 == 'Y' ) {
			$('#modal-input-RUN_SQL_PGM').val( 'Y' );
		} else {
			$('#modal-input-RUN_SQL_PGM').val( 'N' );
		}

if ( inputID == 'IPRUNSQL' )
		{

if ( inputValue == 'Y' ) {
				$('.class-IPSQLSMT').removeClass('d-none');
				$('#modal-input-IPSQLSMT').focus();
			} else {
				$('.class-IPSQLSMT').addClass('d-none');
			}
		}

if ( inputID == 'IPRUNPGM' )
		{

if ( inputValue == 'Y' ) {
				$('.class-IPPGMSMT').removeClass('d-none');
				$('#modal-input-IPPGMSMT').focus();
			} else {
				$('.class-IPPGMSMT').addClass('d-none');
			}
		}

}
	//------------------------------------------------------------

}
//=============================================================================
// Run where?
//=============================================================================
function set_RUN_WHERE( inputValue, inputID )
{

var wrkID 	= 'button-wrk-'  + inputID;
	var mainID 	= 'button-main-' + inputID;
	var inputID = 'modal-input-' + inputID;

if ( inputValue == '*WRK' ) {
		$('#' + wrkID).removeClass('btn-primary').addClass('btn-success');
		$('#' + mainID).removeClass('btn-success').addClass('btn-primary');
	}
	if ( inputValue == '*MAIN' ) {
		$('#' + wrkID).removeClass('btn-success').addClass('btn-primary');
		$('#' + mainID).removeClass('btn-primary').addClass('btn-success');
	}
	if ( inputValue == '' ) {
		$('#' + wrkID).removeClass('btn-success').addClass('btn-primary');
		$('#' + mainID).removeClass('btn-success').addClass('btn-primary');
	}

$('#' + inputID).val(inputValue);
}

//=============================================================================
// Set default modal input fields
//=============================================================================
function setModalInputDefaultFields()
{

var myIPFILENAME = $('#input-IPFILENAME').val();

$('#modal-input-IPACTIV').val('1');
			$('#modal-input-IPIMPSEQ').val('10');

$('#modal-input-IPLIBRNAME').val( GLOBAL_CONFIG_RPYIFSLIBR );
			$('#modal-input-IPIFSNAME').val( GLOBAL_CONFIG_RPYIFSPATH );

}

//=============================================================================
// Reset modal input fields
//=============================================================================
function resetModalInputFields()
{

$('#modal-input-IPFILENAME').val('');

$('#modal-input-IPACTIV').val('');
			$('#modal-input-IPIMPSEQ').val('');
			$('#modal-input-IPFILENMWK').val('');
			$('#modal-input-IPLIBRNAME').val('');
			$('#modal-input-IPFILEDESC').val('');
			$('#modal-input-IPIFSNAME').val('');
			$('#modal-input-IPIFSDESC').val('');
			$('#modal-input-IPPATTERN').val('');
			$('#modal-input-IPCPYMAIN').val('');
			$('#modal-input-IPCLRMAIN').val('');
			$('#modal-input-IPCPYF').val('');
			$('#modal-input-IPCPYOPT').val('');
			$('#modal-input-IPRUNSQL').val('');
			$('#modal-input-IPSQLWHR').val('');
			$('#modal-input-IPSQLSMT').val('');
			$('#modal-input-IPRUNPGM').val('');
			$('#modal-input-IPPGMWHR').val('');
			$('#modal-input-IPPGMSMT').val('');
			$('#modal-input-IPCGHATT').val('');

// Reset buttons
			$('#button-reset-IPCPYOPT').click();
			$('#button-reset-IPSQLWHR').click();
			$('#button-reset-IPPGMWHR').click();

$('#input-mode').val('');

}

//=============================================================================
// Log off
//=============================================================================
function signoff()
{

window.location.href = "logout.php";

}

//=============================================================================
// Load page
//=============================================================================
function loadPage(url, p1, p2, p3)
{

window.location.href = url;

}

//=============================================================================
// Reset modal message
//=============================================================================
function resetModalMessage() {

// Reset
	//$('#modal-message').removeClass('p-2 font-weight-bold border border-danger rounded bg-light').html( '&nbsp;' );

$('#modal-message').removeClass('border-bottom').html( '&nbsp;' );
	$('#modal-save-button').removeClass('disabled').prop("disabled", false);

}

//=============================================================================
// Clean input string
//=============================================================================
function cleanInputString( myWorkField )
{

let charactersToRemove = '?#"\'';
	let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');

myWorkField = myWorkField.replace(myPattern,'');

return myWorkField;

}

//=============================================================================
// Full screen popup
//=============================================================================
function popUpFull( url, p1, p2, p3 )
{

var winname = 'win_' + url;

params  = 'width='+screen.width;
	params += ', height='+screen.height;
	params += ', top=0, left=0'
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;

}

//=============================================================================
// screen popup - center
//=============================================================================
function popUpCenter(url, p1, p2, p3)
{

var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

if ( parseInt(v1_w) > 1800 ) {
		v1_w = 1800;
		v1_h = v1_h - 200;
		v1_center = v1_w/0.8;
	}

// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

var winname = 'win_' + url;

params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;

}

//=============================================================================
// screen popup - center - bigger
//=============================================================================
function popUpCenterBig(url, p1, p2, p3)
{

var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

// Get 25%
	v1_w_pct = v1_w * 0.25;

v1_w_new = v1_w - v1_w_pct;

if ( v1_w_new < 1 ) {
		v1_w_new	= 1800;
	}

v1_w = v1_w_new;
	v1_h = v1_h - 200;
	v1_center = v1_w/0.8;

// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

var winname = 'win_' + url;

params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;

}

//=============================================================================
// Popup top
//=============================================================================
function popUpTop(url, p1, p2, p3)
{

var winname = 'win_' + url;

w = 650;
	h = 750;

params  = 'width='+w;
	params += ', height='+h;
	params += ', top=0, left=0'
	params += ', fullscreen=no';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.trigger('focus')}
	return false;
}

let charactersToRemove = '?#"\'';
	let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');

myWorkField = myWorkField.replace(myPattern,'');

return myWorkField;

}

//=============================================================================
// Set config type
//=============================================================================
function setConfigType( inputType )
{

outputType = inputType;

if ( inputType == 'A' ) {
		var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A;
	}
	if ( inputType == 'N' ) {
		var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N;
	}
	if ( inputType == 'L' ) {
		var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L;
	}
	if ( inputType == 'T' ) {
		var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T;
	}

return outputType;

}

//=============================================================================
// Create config type buttons
//=============================================================================
function createConfigTypeButtons()
{

$('#button-group-config-type').html('');

// Char
	myConfigType_A = '<button type="button" id="button-config_type-button-A" class="btn btn-primary btn-config-type mr-1 mb-1" onclick="selectConfigType(\'A\')">' + GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A +'</button>';
	myConfigType_N = '<button type="button" id="button-config_type-button-N" class="btn btn-primary btn-config-type mr-1 mb-1" onclick="selectConfigType(\'N\')">' + GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N +'</button>';
	myConfigType_L = '<button type="button" id="button-config_type-button-L" class="btn btn-primary btn-config-type mr-1 mb-1" onclick="selectConfigType(\'L\')">' + GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L +'</button>';
	myConfigType_T = '<button type="button" id="button-config_type-button-T" class="btn btn-primary btn-config-type mr-1 mb-1" onclick="selectConfigType(\'T\')">' + GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T +'</button>';

$('#button-group-config-type').html(
										myConfigType_A +
										myConfigType_N +
										myConfigType_L +
										myConfigType_T
									   );

}

//=============================================================================
// Select config type
//=============================================================================
function selectConfigType( inputType )
{

$('#modal-input-M1UPP').val( inputType );

// Remove all "active" marks
	$('.btn-config-type').removeClass('active btn-success').addClass('btn-primary');;

// Mark button as selected
	myID = 'button-config_type-button-' + inputType;
	$('#' + myID ).addClass('active btn-success').removeClass('btn-primary');

}

//=============================================================================
// Select line modal
//=============================================================================
function selectGroupValueModal( inputLine )
{

$('#modal-input-IPFILENAME').val( inputLine );

var selectButtonLineID = 'select-button-line-id-modal-' + inputLine;

$('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary');
	$('#' + selectButtonLineID).removeClass('btn-primary').addClass('btn-success');

// Place cursor
	$('#modal-input-IPFILENAME').trigger('focus');
	resetModalMessage();

}

//=============================================================================
// Reset line modal
//=============================================================================
function resetLineModal()
{

resetModalMessage()

let inputLine = $('#modal-input-IPFILENAME').val();

if ( inputLine == '' ) {
		$('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary');
	}

}

//=============================================================================
// Set action type
//=============================================================================
function setActionType( inputType )
{

outputType = '';

if ( inputType == '*PDF' ) {
		outputType = '1';
	}
	if ( inputType == '*PIC' ) {
		outputType = '2';
	}
	if ( inputType == '*SCAN' ) {
		outputType = '3';
	}
	if ( inputType == '*MOVIE' ) {
		outputType = '4';
	}
	if ( inputType == '*LINK' ) {
		outputType = '5';
	}
	if ( inputType == '*CHECK' ) {
		outputType = '6';
	}

return outputType;

}

//=============================================================================
// Open previewer
//=============================================================================
function preViewElement( myElement )
{

let h = $(window).height();
	let w = $(window).width();

console.log('h: ' + h + ' -- ' + 'w: ' + w);

h = h * 0.75;

console.log('h: ' + h + ' -- ' + 'w: ' + w);

// Create ID
	let myID = '#' + myElement;
	let myURL = $( myID ).val();
	let myIFRAME = '<iframe style="height:' + h + 'px;width:100%;" src=' + myURL +'></iframe>';

// Set iframe
	$('#modal-preview-iframe').html( myIFRAME );

// Show modal
	$('#hub_import_previewModal').modal('show');

}

//=============================================================================
// Get data - search
//=============================================================================
function setWebserviceSearch( input_IPFILENAME )
{

// Save curreent webservice name
	$('#input-IPFILENAME').val( input_IPFILENAME );

var selectButtonLineID 		= 'select-button-line-id-' + input_IPFILENAME;

// Set clicked button
	$('.select-button-line').removeClass('btn-success').addClass('btn-dark');
	$('#' + selectButtonLineID).removeClass('btn-dark').addClass('btn-success');

// Clear table - note the draw will occur in the getData function
	$('#REEFTvisual_data').DataTable().clear();
	getData();

}

//=============================================================================
// Close modal
//=============================================================================
function closeModal() {

$('#hub_import_MaintainModal').modal('hide');

}

//=============================================================================
// Set clock
//=============================================================================
function updateClock() {

var currentTime = moment().format('YYYY-MM-DD HH:mm:ss');
	currentTime = REEFT_format_date( currentTime, DFT_DATE_DISPLAY_FORMAT )

$('#input-current-date').val( moment().format('YYYY-MM-DD') );
	$('#input-current-time').val( moment().format('HH:mm:ss') );

$('#current-time').html( currentTime );

// If add mode update date/time in modal window
	if ( $('#input-mode').val() == '*add' )
	{

$('#modal-input-M1VLT').val( $('#input-current-date').val() );
		$('#modal-input-M3HTZ').val( $('#input-current-time').val() );

}

//=============================================================================
// jQuery - Ready
//=============================================================================
$(document).ready(function()
{

// When closing modal
	$('#hub_import_MaintainModal').on('hidden.bs.modal', function (e) {
		resetModalInputFields();
	})

// Do not show deleted
	$('#input-show-deleted').val('Y');
	$('#input-IPFILENAME-exist').val('N');

// Get data done by datatables
	setDataTables();

$('#delay-marker-id').html('<i id="delay-marker-icon-id" class="text-success fa-solid fa-circle"></i>');

//-----------------------------------------------------------------------
	// Start the clock
	//-----------------------------------------------------------------------
		updateClock();
		setInterval(function() {
			updateClock();
		}, 1000); 
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Set font awesome icon type
	//-----------------------------------------------------------------------
	// Value is from config/config.php
	var iconType = '<?php echo $DFT_SET_FONT_AWESOME_ICON_TYPE ?>';
	setFontAwesomeIconType( iconType );
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Delay keyup checker
	//-----------------------------------------------------------------------
	var delay = (function () {
		var timer = 0;
		return function (callback, ms) {
			clearTimeout(timer);
			timer = setTimeout(callback, ms);
		};
	})()

// DataTable search delay
	$('#REEFTvisual_data_wrapper div.dt-search .dt-input')
    .unbind() // overrule normal behavior
    .bind('keyup', function(e){

$('#delay-marker-icon-id').removeClass('text-success').addClass('text-danger');

var inputValue = $('#REEFTvisual_data_wrapper div.dt-search .dt-input').val();
		var currSearchValue = $('#input-search-line').val();

if (inputValue != currSearchValue) {
			$('#input-search-line').val( inputValue );
			//If enter or delete we update immediately, consider to add backspace=8 and delete=46 also
			const keyList = [13];
			if (keyList.includes(e.keyCode)) {
				// console.log('immediately ' + inputValue );
				$('#delay-marker-icon-id').removeClass('text-danger').addClass('text-success');
				thisGlobalTableData.search(inputValue).draw(); // fire in the hole
			} else {
				delay(function () {
					// console.log('this will hit, once user has not typed for 1 second ' + inputValue );
					$('#delay-marker-icon-id').removeClass('text-danger').addClass('text-success');
					thisGlobalTableData.search(inputValue).draw(); // fire in the hole
				}, 0800);
			}
		}
	});

//-----------------------------------------------------------------------
	// Check exists
	//-----------------------------------------------------------------------
	let $filter01 = $('#modal-input-IPFILENAME');
	$filter01.on('keyup', function () {
		delay(function () {
			var inputValue = $('#modal-input-IPFILENAME').val();
			if ( inputValue != '') {
				console.log('this will hit, once user has not typed for 1 second ' + inputValue );
				checkDataExists();
			}
		}, 0800);
	});

//-----------------------------------------------------------------------
	// Event listener for the update button
	//-----------------------------------------------------------------------
    $('#updateButton').on('click', function() {

// Trigger a redraw of the table
        thisGlobalTableData.draw();
    });

//-----------------------------------------------------------------------
	// Set short cuts
	//-----------------------------------------------------------------------

// If add d-none class, do not add shortcut
	if ( GLOBAL_ADD_ALLOWED == 'Y' ) {
		shortcut.add("Alt+F6",function() {
			$('#add-button').click();
		});

// Show add button
		$('#add-button').removeClass('d-none');
	}

// Close window
	shortcut.add("Shift+Esc",function() {
		$('#button-close').click();
	});

});
// -->
</script>

</head>

<body>

</div>
		</div>

</div>
				</div>
			</div>

<div class="container-fluid mt-2 mb-4 d-block d-lg-none">
					<div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div>
				</div>

<div class="d-none d-lg-block">
					<div class="row mb-2">
						<div class="col-12">
							<div id="data-result-button-group"></div>
						</div>
					</div>
				</div>

<div class="row mt-2">
					<div class="col">
						<div id="data-result" style="width: 100%;"></div>
							<table id="REEFTvisual_data" class="table nowrap table-bordered table-striped table-hover">
								<thead>
									<tr class="bg-primary text-white font-weight-bold text-center">
										<th class="text-center"><?php echo $datahub_text0007 ?></th>
										<th class="text-left"><?php echo $datahub_text0003 ?></th>
										<th class="text-left"><?php echo $datahub_text0008 ?></th>
										<th class="text-left"><?php echo $datahub_text0009 ?></th>
										<th class="text-left"><?php echo $datahub_text0010 ?></th>
										<th class="text-center"><?php echo $datahub_text0014a ?></th>
										<th class="text-center"><?php echo $datahub_text0015a ?></th>
										<th class="text-center"><?php echo $datahub_text0162a ?></th>
										<th class="text-left"><?php echo $datahub_text0013a ?></th>
										<th class="text-left"><?php echo $datahub_text0164 ?></th>
										<th class="text-center"><?php echo $datahub_text0163 ?></th>
										<th class="text-left"><button type="button" id="add-button" title="Shortcut: Alt+F6" onclick="dataAdd('0')" class="d-none btn btn-dark btn-block font-weight-bold"><?php echo $datahub_button_save_01 ?></button></th>
										<th class="text-left"></th>
										<th class="text-left">IPACTIV</th>
										<th class="text-left">IPIFSNAME</th>
										<th class="text-left">IPIFSDESC</th>
										<th class="text-left">IPRUNSQL</th>
										<th class="text-left">IPSQLWHR</th>
										<th class="text-left">IPSQLSMT</th>
										<th class="text-left">IPRUNPGM</th>
										<th class="text-left">IPPGMWHR</th>
										<th class="text-left">IPPGMSMT</th>
										<th class="text-left">IPCGHATT</th>
										<th class="text-left">IPCPYF</th>
										<th class="text-left"></th>
										<th class="text-left"></th>
										<th class="text-left"><?php echo $datahub_text0221 ?></th>

</tr>
								</thead>
							</table>

</div>
				</div>

</div>

<?php
	include "include/footer.php";
?>

<div class="modal fade" id="hub_import_MaintainModal" tabindex="-1" data-backdrop="static" role="dialog" aria-labelledby="hub_import_MaintainModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-xxl">
    <div class="modal-content">

</div>
			<div class="col-1 text-right" style="max-width:20px">
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
				  <span aria-hidden="true">&times;</span>
				</button>
			</div>

</div>
		</div>

</div>
      <div class="modal-body ml-2 mr-2">

</div>

<div class="row mt-2">
				<div class="col-3">
					<?php echo $datahub_text0013 ?>
				</div>
				<div class="col-5">
					<button type="button" onclick="setCpyF_option('*ADD')" 		class="btn btn-primary cpy_opt-button" id="button-add-IPCPYOPT">*ADD</button>
					<button type="button" onclick="setCpyF_option('*REPLACE')" 	class="btn btn-primary cpy_opt-button" id="button-rpl-IPCPYOPT">*REPLACE</button>
					<button type="button" onclick="setCpyF_option('*UPDADD')" 	class="btn btn-primary cpy_opt-button" id="button-upd-IPCPYOPT">*UPDADD</button>
					<button type="button" onclick="setCpyF_option('')" 			class="btn btn-warning               " id="button-reset-IPCPYOPT">Reset</button>
					<input class="form-control d-none" type="text" id="modal-input-IPCPYOPT" name="modal-input-IPCPYOPT" onkeyup="resetModalMessage()">
				</div>
			</div>

<div class="row mt-2 mb-2">
						<div class="col-3">
							<?php echo $datahub_text0017 ?>
						</div>
						<div class="col-4">
							<button type="button" onclick="set_RUN_WHERE( '*WRK', 'IPSQLWHR' )" class="btn btn-primary" id="button-wrk-IPSQLWHR">*WRK</button>
							<button type="button" onclick="set_RUN_WHERE( '*MAIN', 'IPSQLWHR' )" class="btn btn-primary" id="button-main-IPSQLWHR">*MAIN</button>
							<button type="button" onclick="set_RUN_WHERE( '', 'IPSQLWHR' )" class="btn btn-warning" id="button-reset-IPSQLWHR">Reset</button>
							<input class="form-control d-none" type="text" id="modal-input-IPSQLWHR" 	name="modal-input-IPSQLWHR"	onkeyup="resetModalMessage()">
						</div>
					</div>

</div>
			</div>

<div class="row mt-2 mb-2">
						<div class="col-3">
							<?php echo $datahub_text0020 ?>
						</div>
						<div class="col-4">
							<button type="button" onclick="set_RUN_WHERE( '*WRK', 'IPPGMWHR' )" class="btn btn-primary" id="button-wrk-IPPGMWHR">*WRK</button>
							<button type="button" onclick="set_RUN_WHERE( '*MAIN', 'IPPGMWHR' )" class="btn btn-primary" id="button-main-IPPGMWHR">*MAIN</button>
							<button type="button" onclick="set_RUN_WHERE( '', 'IPPGMWHR' )" class="btn btn-warning" id="button-reset-IPPGMWHR">Reset</button>
							<input class="form-control d-none" type="text" id="modal-input-IPPGMWHR" 	name="modal-input-IPPGMWHR"	onkeyup="resetModalMessage()">
						</div>
					</div>

</div>
			</div>

</form>

</div>
      <div class="modal-footer-pretty modal-footer">

</div>

</div>
    </div>
  </div>
</div>

<div class="modal fade" id="hub_import_confirmDeleteModal" tabindex="-1" role="dialog" aria-labelledby="hub_import_confirmDeleteModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header bg-primary text-white">
        <h5 class="modal-title" id="hub_import_confirmDeleteModalLabel"><?php echo $datahub_text0063 ?></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">

</form>

</div>
      <div class="modal-footer">

</div>
      </div>
    </div>
  </div>
</div>

</body>
</html>